insert overwrite table jms_dim.dim_sys_network_detail_dt partition(dt)
select
     id
    ,name
    ,code
    ,signature_code
    ,cn_name
    ,en_name
    ,country_id
    ,country_code
    ,country_desc
    ,country_three_code
    ,regional_id
    ,regional_desc
    ,area_info_id
    ,area_info_desc
    ,provider_id
    ,provider_desc
    ,city_id
    ,city_desc
    ,area_id
    ,area_desc
    ,township_id
    ,principal
    ,mobile
    ,telephone
    ,parent_network_id
    ,parent_network_code
    ,parent_network_name
    ,financial_center_id
    ,financial_center_code
    ,financial_center_desc
    ,function_type_id
    ,function_type_desc
    ,type_id
    ,type_desc
    ,institutional_level_id
    ,institutional_level_desc
    ,max_collection_money
    ,settlement_destination_id
    ,settlement_destination_desc
    ,is_collection_identifier
    ,is_distribution_center
    ,business_model_id
    ,business_model_desc
    ,local_currency_id
    ,local_currency_code
    ,local_currency_desc
    ,is_financial_center
    ,is_waybill_identification
    ,is_to_payment
    ,is_visibility
    ,is_enable
    ,is_leaf
    ,is_delete
    ,address
    ,business_principal
    ,business_telephone
    ,customer_service_principal
    ,customer_service_telephone
    ,longitude
    ,latitude
    ,create_by
    ,update_by
    ,create_by_name
    ,update_by_name
    ,create_time
    ,update_time
    ,version
    ,sort
    ,remark
    ,path
    ,is_receiving
    ,is_dispatch
    ,zip_code
    ,start_business_time
    ,end_business_time
    ,last_update_time_sync
    ,coordinate
    ,subordinate_agent
    ,is_first_network_settle
    ,simple_name
    ,is_first_franchisee
    ,is_second_franchisee
    ,is_entrepot
    ,to_payment_limit
    ,opening_type
    ,opening_time
    ,is_retrogression
    ,is_suspend
    ,leaving_time
    ,agent_id
    ,agent_code
    ,agent_name
    ,fran_id     as franchisee_id
    ,fran_code   as franchisee_code
    ,fran_name   as franchisee_name
    ,center_id   as transcenter_id
    ,center_code as transcenter_code
    ,center_name as transcenter_name
    ,'{{ execution_date | cst_ds }}' as dt
from jms_dim.dim_network_whole_massage
distribute by 1 ;